1/
create view v_emp_pw2
as
select empno,ename,sal,job,deptno
from emp_pw
where deptno=20
2/
create sequence seq_emp_pw2
start with 10
increment by 10
3/
select seq_emp_pw2.nextval
from dual
4/
select seq_emp_pw2.currval
from dual
5/
create index idx_emp_pw2_ename on emp_pw(ename)
6/
create index idx_emp_pw2_upper_ename 
              on emp_pw(upper(ename))
7/
create index idx_emp_pw2_sal_comm on emp_pw(sal,comm)
8/
create table myemp_pw2(
id number(4) primary key,
name varchar2(20) not null,
birthday date,
telephone varchar2(11) unique,
score number(9,2),
constraint emp_pw2_score_ck check(score>=0)
)


